USE [texchange_db]
GO

/****** Object:  StoredProcedure [dbo].[SP_InsLinksRoot]    Script Date: 05/29/2011 19:47:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE proc [dbo].[SP_InsLinksRoot] 
  @link nvarchar(150),
  @language_id int,
  @link_text nvarchar(150),
  @isActive bit
as
	INSERT INTO Links ([link], [link_text], [isActive], [language_id])
	VALUES (@link, @link_text,@isActive, @language_id)
Select @@Identity as lastID

SET NOCOUNT OFF
GO


